Logical design of relational databases based on the principles of normalization

• Storogok E.A.

Within the limits of the given work research of possibilities of automation of process of normalization of the scheme of a relational database is conducted. An important design stage of a relational DB is logic designing. The given stage is carried out after a choice of a concrete control system by a database. More often logic designing is based on normalization principles. Result of logic designing – the DB scheme (set of schemes of the relations entering into a DB). The normalization principle assumes removal from relations of a DB of superfluous dependences which can lead to infringement of integrity of the data during performance of transactions. Normalization process gives some variants of the third normal form. There is a necessity of a choice from these variants of the best. The given choice can be organized with use of such criteria, as volume of occupied memory and speed of performance of transactions.